<%@page import="java.util.Calendar"%>
<%@page import="com.nayuta.aipo.dao.ScheduleUtils.ScheduleBean"%>
<%@page import="java.text.SimpleDateFormat"%>
<%@page import="java.util.List"%>
<%@page import="java.util.Date"%>
<%@page import="com.nayuta.aipo.dao.ScheduleUtils"%>
<%@page import="com.nayuta.aipo.dao.JDBCUtils"%>
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.Statement"%>
<%@page import="java.sql.Connection"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=US-ASCII">
<title>Insert title here</title>
</head>
<body>

<%  
Calendar startDate = Calendar.getInstance();
startDate.set(Calendar.DATE, 1);
Calendar endDate = Calendar.getInstance();
endDate.set(Calendar.DATE, 28);
ScheduleBean ret = ScheduleUtils.getScheduleList(Integer.valueOf((String) request.getParameter("user_id")), startDate.getTime(), endDate.getTime(), null, null);
ResultSet rs = ret.getConnectionBean().getRs();
out.println(ret.getSql() + "<br />");
while(rs.next()) {
	out.println("========================================<br />");
	out.println(rs.getRow() + "件目<br />");
	for (int i = 1; i <= rs.getMetaData().getColumnCount(); i++) {
		out.print(rs.getMetaData().getColumnName(i) + " : ");
		out.println(rs.getString(i) + "<br />");
	}
	out.println("========================================<br />");
}
%>
</body>
</html>